SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{c416de54f39e9211ee305af3353b6f9669d2286959073301486101ac9400c10b}Halsenbach{c416de54f39e9211ee305af3353b6f9669d2286959073301486101ac9400c10b}' OR prCity = 'Halsenbach' OR prZip = 'Halsenbach' OR prStreet LIKE '{c416de54f39e9211ee305af3353b6f9669d2286959073301486101ac9400c10b}Halsenbach{c416de54f39e9211ee305af3353b6f9669d2286959073301486101ac9400c10b}' OR prCountry = 'Halsenbach') AND (prLocation LIKE '{c416de54f39e9211ee305af3353b6f9669d2286959073301486101ac9400c10b}Germany{c416de54f39e9211ee305af3353b6f9669d2286959073301486101ac9400c10b}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{c416de54f39e9211ee305af3353b6f9669d2286959073301486101ac9400c10b}Germany{c416de54f39e9211ee305af3353b6f9669d2286959073301486101ac9400c10b}' OR prCountry = 'Germany')